//package com.css.fxfzdzzh.util;
//
///**
// * @author Dbj
// * @date 2023年03月01日  9:33
// */
//public class SqlDistrictUtil {
//    public static String buildDistrictSql(String province,String city,String area){
//        StringBuilder builder = new StringBuilder();
//        if (PlatformObjectUtils.isNotEmpty(province)) {
//            if (PlatformObjectUtils.isNotEmpty(city)) {
//                if (PlatformObjectUtils.isNotEmpty(area)) {
//                    sql = sql + " and (taskDistrict like '%" + province + "-" + city + "-" + area + "%'" +
//                            " or taskDistrict like '%" + param.getProvince() + "-" + param.getCity() + "、%' or taskDistrict = " + param.getProvince() + "-" + param.getCity() +
//                            " or taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//                    countSql = countSql + " and (taskDistrict like '%" + param.getProvince() + "-" + param.getCity() + "-" + param.getArea() + "%'" +
//                            " or taskDistrict like '%" + param.getProvince() + "-" + param.getCity() + "、%' or taskDistrict = " + param.getProvince() + "-" + param.getCity() +
//                            " or taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//                } else {
//                    sql = sql + " and (taskDistrict like '%" + param.getProvince() + "-" + param.getCity() + "、%' or taskDistrict = " + param.getProvince() + "-" + param.getCity() +
//                            " or taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//                    countSql = countSql + " and (taskDistrict like '%" + param.getProvince() + "-" + param.getCity() + "、%' or taskDistrict = " + param.getProvince() + "-" + param.getCity() +
//                            " or taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//                }
//            } else {
//                sql = sql + " and (taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//                countSql = countSql + " and ( taskDistrict like '%" + param.getProvince() + "、%'or taskDistrict = " + param.getProvince() + ")";
//            }
//
//        }
//    }
//}
